EMT Practice Test

1. Question Content...

---

Question1: Which join type is NOT supported by join optimization (pruning)? Please choose the correct answer.

Question2: What are the issue categories that SQL Script Code Analyser scans for? There are 3 correct answers to this question.

Question3: Which development environment does SAP recommend to develop an SAP HANA extended application services; advanced model (XS advanced) multi-target application?

Question4: You need to manage an exception in a SQLScript.
Which SQLScript features can you use?
Note: There are 2 correct answers to this question.

Question5: Which parameters does the APPLY_FILTER function support? There are 2 correct answers to this question.

Question6: You want to exclusively use declarative logic in an SQL Script procedure. Which of the following operators can you use? There are 2 correct answers to this question.

Question7: What characterizes the Node.js environment? Note: There are 2 correct answers to this question.

Question8: Which OData capacities are supported in SAP HANA extended application services, advanced model (XSA)?
There are 3 correct answers to this question.

Question9: To perform a specific task of an XS advanced application, what does a user need? Please choose the correct answer.

Question10: Which SAP HANA system views contain information about the object ownership? There are 2 correct answers to this question.

Question11: You create an isolated block of code which runs as an independent transaction. Which of the following SQLScript features do you use?

Question12: Which GIT command do you use to consolidate all changes from one branch with another branch using a single commit?

Question13: In application development with XS advanced, which of the following entities belong to a specific SPACE?
There are 2 correct answers to this question.

Question14: Which of the following are characteristics of an SAP HANA Deployment Infrastructure container? Note:
There are 3 correct answers to this question.

Question15: For what do you use the RESIGNAL statement in SQLScript?

Question16: Which new components can you use to develop native SAP HANA applications in SAP HANA extended application services; advanced model (XS advanced)? Note: There are 2 correct answers to this question.

Question17: You define exception handling in a SQLScript procedure. What can you use declare exit handlers for? Note:
There are 2 correct answers to this question.

Question18: What are the characteristics of SAP HANA calculation views? There are 2 correct answers to this question.

Question19: You create a simple data model to store user information. The model contains two tables: One for the user information, the other for user address details. The user can only have one address. You also need a view to show the complete information of the user including the address. Which actions to you perform if you use CDS artifacts only?

Question20: You need to view the data model exposed by an OData V2 service. What must you append to the service URL?

Question21: Which of the following information must you specify when you create a new project in SAP Web IDE for SAP HANA?
Note: There are 2 correct answers to this question.

Question22: In which of the following objects can you use Commit and Rollback statements?

Question23: What are the main SAP HANA engines responsible for executing calculation views? There are 3 correct answers to this question.

Question24: You configure an OData service for a transactional SAPUI5 application What is the default data access behavior of the OData service?

Question25: You need to create a native SAP HANA application that fully leverages the SAP HANA platform. How do you implement data-intensive calculations?

Question26: You need to install SAP HANA 2.0, express edition to develop a native SAP HANA application. Which of the following deployment options do you have? Note: There are 2 correct answers to this question.

Question27: Which tool do you use to create a calculation view in a multi-target application?

Question28: You develop native SAP HANA applications in SAP HANA extended application services, advanced model (XS advanced).
What are some of the advantages compared to developing in SAP HANA extended application services, classic model (XS classic)?
Note: There are 3 correct answers to this question.

Question29: You need to bind UI5 controls to a data source.
Between which parts of the SAPUI5 application must you create data binding?

Question30: In a calculation view, what are the different types of input mapping available in Table Function? There are 2 correct answers to this question.

Question31: You need to synchronize all unsynchronized changes of the remote GIT branch with a local GIT branch.
Which operation do you use?

Question32: You implement a native SAP HANA application using SAP HANA extended application services, advanced mode (XS advanced) and SAPUI5.
Where is the UI rendering executed?

Question33: You need to check user input data in your OData request. Which exit type do you use?

Question34: In your UI5 application, you need to refer to an SAPUI5 core library that is available on your SAP HANA extended application services, advanced model (XS advanced) server.
Which files must you adapt?
Note: There are 3 correct answers to this question.

Question35: You create an SAP HANA extended application services, advanced model (XS advanced) multi-target application using the SAP Web IDE for SAP HANA.
Which files can be generated automatically by the wizard when you create the SAP HANA database (HDB) module?
Note: There are 2 correct answers to this question.

Question36: You need to create a native SAP HANA application that fully leverages the SAP HANA platform. How do you implement data-intensive calculations?

Question37: What happens if you define a database object in the persistence model and deploy it using the SAP HANA Deployment Infrastructure (HDI)?

Question38: Which configuration file indicates the program that is executed upon startup when you run the Node.js module?

Question39: A Node.js module is executed for the first time in SAP HANA extended application services, advanced model (XS advanced). Which of the following activities are performed automatically? There are 2 correct answers to this question.

Question40: What do you reference in a role template? Please choose the correct answer.

Question41: You use path expressions (associations) in your Core Data Services to combine entities instead of using SQL joins.
What is a benefit to use these associations?